alter table deleted_problem alter column PROBLEM_TITLE varchar(100) null
go
alter table deleted_problem alter column PROBLEM_CONTENT varchar(500) null
go
alter table deleted_problem alter column PROBLEM_ZHENGGAI_CUOSHI varchar(500) null
go
/****** Object:  Table [dbo].[postcheck_standard]    Script Date: 08/07/2012 13:19:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[postcheck_standard](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[POSTCHECK_ID] [int] NOT NULL,
	[POSTCHECK_PATTERN_ID] [int] NOT NULL,
	[POSTCHECK_CONTENT_ID] [int] NOT NULL,
	[STANDARD] [varchar](500) NOT NULL,
	[SOURCES] [varchar](200) NULL,
	[GRADE_STANDARD] [varchar](200) NULL,
	[CHECK_FREQUENCY] [varchar](200) NULL,
 CONSTRAINT [PK_postcheck_standard] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[postcheck_source]    Script Date: 08/07/2012 13:19:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[postcheck_source](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[NAME] [varchar](500) NOT NULL,
 CONSTRAINT [PK_postcheck_source] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],
 CONSTRAINT [IX_postcheck_source] UNIQUE NONCLUSTERED 
(
	[NAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[postcheck_pattern]    Script Date: 08/07/2012 13:19:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[postcheck_pattern](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[POSTCHECK_ID] [int] NOT NULL,
	[PATTERN] [varchar](200) NOT NULL,
 CONSTRAINT [PK_postcheck_item] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[postcheck_content]    Script Date: 08/07/2012 13:19:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[postcheck_content](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[POSTCHECK_ID] [int] NOT NULL,
	[POSTCHECK_PATTERN_ID] [int] NOT NULL,
	[CONTENT] [varchar](500) NOT NULL,
 CONSTRAINT [PK_postcheck_aa] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
